Biweekly Mortgage
Use this template to create a bi-weekly mortgage amortization schedule. This bi-weekly amortization assumes that the borrower will make 26 payments per year, as opposed to a traditional mortgage where the 12 monthly payments per year is the norm. The template is designed to accept up to 30 years as a loan term. Enter all input values or #VALUE will be displayed in the amortization schedule. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Bi-Weekly Mortgage Amortization
KEY FIGURES
Annual Loan Payments Bi-Weekly Payments Interest Over Term of Loan Sum of All Payments
INPUTS
Loan Principal Amount Annual Interest Rate Loan Period in Years (30 Max) Base Year Loan Start Date Date of First Payment
First 26 Payments
Payment # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Payment Date Beginning Balance Payment Principal Interest Cumulative Principal Cumulative Interest Ending Balance
Payments for Calendar Years after Year 1
Year Beginning Balance Payment Principal Interest Ending Balance